package com.hefeng.unit.mapper;

import cn.hutool.extra.tokenizer.Result;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hefeng.unit.domain.GyDeviceSon;
import org.apache.ibatis.annotations.*;

import java.util.List;
import java.util.Map;

@Mapper
public interface GyDeviceSonMapper extends BaseMapper<GyDeviceSon> {


    /**
     * 获取探头数量
     * @param userId
     * @return
     */
    @Select("SELECT\n" +
            "\tCOUNT(*)\n" +
            "FROM\n" +
            "\tgy_device_user\n" +
            "WHERE\n" +
            "\tgy_device_user.is_delete = 1 AND\n" +
            "\tgy_device_user.user_id = #{userId}")
    int quantityT(@Param("userId") String userId);





}
